searchenginetracker: Optimize direct/recursive folder lookups
authorCarlos Garnacho <carlosg@gnome.org>
Fri, 20 Nov 2015 18:04:39 +0000 (19:04 +0100)
committerCarlos Garnacho <carlosg@gnome.org>
Mon, 23 Nov 2015 16:58:34 +0000 (17:58 +0100)
commitf6dd0438d12a2cc6a298b08fc3992bef5cb8d542
tree2f324a0f149cab95c73dfbdd150258e71967aa24
parent61d6c1a523385cc1fe724cbe1cc8ad9545e6cc43
searchenginetracker: Optimize direct/recursive folder lookups

tracker:uri-is-descendant/parent has the unfortunate side effect of
rendering the collation mechanisms in the database useless, so those
require full table scans to be validated.

Performing these as pure string comparisons will perform much better,
as those allow the underlying sqlite to rely on its own collation
to perform the search, which can be significantly faster with many
elements in the database.

https://bugzilla.gnome.org/show_bug.cgi?id=758407
gtk/gtksearchenginetracker.c